package com.jeecg.demo.entity;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import javax.persistence.TableGenerator;

import org.jeecgframework.poi.excel.annotation.Excel;

/**
 * @Title: Entity
 * @Description: SYS_USER
 * @author onlineGenerator
 * @date 2018-11-15 13:42:49
 * @version V1.0
 * 
 */
@Entity
@Table(name = "sys_user", schema = "")
@SuppressWarnings("serial")
public class SysUserEntity implements java.io.Serializable {
    /** ID */
    private java.lang.Integer id;
    /** 用户编号 */
    private java.lang.Integer userid;
    /** 系统编号 */
    private java.lang.Integer sysid;
    /** 登录名 */
    @Excel(name = "登录名", width = 15)
    private java.lang.String loginname;
    /** 登陆密码 */
    private java.lang.String password;
    /** 用户姓名 */
    @Excel(name = "用户姓名", width = 15)
    private java.lang.String username;
    /** 性别 */
    @Excel(name = "性别", width = 15, dicCode = "SEX")
    private java.lang.String sex;
    /** 角色编号字符串 */
    @Excel(name = "角色编号字符串", width = 15)
    private java.lang.String roleid;
    /** 所属交易商或部门编号 */
    @Excel(name = "所属交易商或部门编号", width = 15)
    private java.lang.Integer orgid;
    /** 身份证号 */
    @Excel(name = "身份证号", width = 15)
    private java.lang.String certno;
    /** 移动电话 */
    @Excel(name = "移动电话", width = 15)
    private java.lang.String mobile;
    /** 电子邮件 */
    @Excel(name = "电子邮件", width = 15)
    private java.lang.String email;
    /** 用户类型 */
    @Excel(name = "用户类型", width = 15, dicCode = "YONGHLX")
    private java.lang.String usertype;
    /** 是否有效 */
    @Excel(name = "是否有效", width = 15, dicCode = "ISN")
    private java.lang.String isvalid;
    /** 买卖类型 */
    @Excel(name = "买卖类型", width = 15, dicCode = "MAIMLX")
    private java.lang.String maimlx;
    /** 录入人 */
    @Excel(name = "录入人", width = 15)
    private java.lang.Integer operator;
    /** 录入时间 */
    @Excel(name = "录入时间", width = 15, format = "yyyy-MM-dd")
    private java.util.Date operationtime;
    /** lastlogin */
    private java.util.Date lastlogin;
    /** iplimit */
    private java.lang.String iplimit;
    /** 用户状态 */
    @Excel(name = "用户状态", width = 15, dicCode = "USERVERIFYSTATUS")
    private java.lang.String userverifystatus;
    /** 注册来源 */
    @Excel(name = "注册来源", width = 15, dicCode = "REGSOURCE")
    private java.lang.String regsource;
    /** userpicurl */
    private java.lang.String userpicurl;
    /** tenantid */
    private java.lang.Integer worktypeid;

    /**
     *方法: 取得java.lang.Integer
     * 
     * @return: java.lang.Integer ID
     */
    @Id
    @GeneratedValue(strategy = GenerationType.TABLE, generator = "SYS_USER")
    @TableGenerator(name = "SYS_USER", pkColumnValue = "SYS_USER", table = "sys_sequence", pkColumnName = "name", valueColumnName = "sysid", initialValue = 1, allocationSize = 1)
    @Column(name = "ID", nullable = true, length = 20)
    public java.lang.Integer getId() {
        return this.id;
    }

    /**
     *方法: 设置java.lang.Integer
     * 
     * @param: java.lang.Integer ID
     */
    public void setId(java.lang.Integer id) {
        this.id = id;
        this.userid = id;
        this.sysid = id;
    }

    /**
     *方法: 取得java.lang.Integer
     * 
     * @return: java.lang.Integer 用户编号
     */

    @Column(name = "USERID", nullable = false, length = 19)
    public java.lang.Integer getUserid() {
        return this.userid;
    }

    /**
     *方法: 设置java.lang.Integer
     * 
     * @param: java.lang.Integer 用户编号
     */
    public void setUserid(java.lang.Integer userid) {
        this.userid = userid;
    }

    /**
     *方法: 取得java.lang.Integer
     * 
     * @return: java.lang.Integer 系统编号
     */

    @Column(name = "SYSID", nullable = false, length = 19)
    public java.lang.Integer getSysid() {
        return this.sysid;
    }

    /**
     *方法: 设置java.lang.Integer
     * 
     * @param: java.lang.Integer 系统编号
     */
    public void setSysid(java.lang.Integer sysid) {
        this.sysid = sysid;
    }

    /**
     *方法: 取得java.lang.String
     * 
     * @return: java.lang.String 登录名
     */

    @Column(name = "LOGINNAME", nullable = false, length = 50)
    public java.lang.String getLoginname() {
        return this.loginname;
    }

    /**
     *方法: 设置java.lang.String
     * 
     * @param: java.lang.String 登录名
     */
    public void setLoginname(java.lang.String loginname) {
        this.loginname = loginname;
    }

    /**
     *方法: 取得java.lang.String
     * 
     * @return: java.lang.String 登陆密码
     */

    @Column(name = "PASSWORD", nullable = false, length = 50)
    public java.lang.String getPassword() {
        return this.password;
    }

    /**
     *方法: 设置java.lang.String
     * 
     * @param: java.lang.String 登陆密码
     */
    public void setPassword(java.lang.String password) {
        this.password = password;
    }

    /**
     *方法: 取得java.lang.String
     * 
     * @return: java.lang.String 用户姓名
     */

    @Column(name = "USERNAME", nullable = true, length = 50)
    public java.lang.String getUsername() {
        return this.username;
    }

    /**
     *方法: 设置java.lang.String
     * 
     * @param: java.lang.String 用户姓名
     */
    public void setUsername(java.lang.String username) {
        this.username = username;
    }

    /**
     *方法: 取得java.lang.String
     * 
     * @return: java.lang.String 性别
     */

    @Column(name = "SEX", nullable = true, length = 10)
    public java.lang.String getSex() {
        return this.sex;
    }

    /**
     *方法: 设置java.lang.String
     * 
     * @param: java.lang.String 性别
     */
    public void setSex(java.lang.String sex) {
        this.sex = sex;
    }

    /**
     *方法: 取得java.lang.String
     * 
     * @return: java.lang.String 角色编号字符串
     */

    @Column(name = "ROLEID", nullable = false, length = 200)
    public java.lang.String getRoleid() {
        return this.roleid;
    }

    /**
     *方法: 设置java.lang.String
     * 
     * @param: java.lang.String 角色编号字符串
     */
    public void setRoleid(java.lang.String roleid) {
        this.roleid = roleid;
    }

    /**
     *方法: 取得java.lang.Integer
     * 
     * @return: java.lang.Integer 所属交易商或部门编号
     */

    @Column(name = "ORGID", nullable = false, length = 19)
    public java.lang.Integer getOrgid() {
        return this.orgid;
    }

    /**
     *方法: 设置java.lang.Integer
     * 
     * @param: java.lang.Integer 所属交易商或部门编号
     */
    public void setOrgid(java.lang.Integer orgid) {
        this.orgid = orgid;
    }

    /**
     *方法: 取得java.lang.String
     * 
     * @return: java.lang.String 身份证号
     */

    @Column(name = "CERTNO", nullable = true, length = 30)
    public java.lang.String getCertno() {
        return this.certno;
    }

    /**
     *方法: 设置java.lang.String
     * 
     * @param: java.lang.String 身份证号
     */
    public void setCertno(java.lang.String certno) {
        this.certno = certno;
    }

    /**
     *方法: 取得java.lang.String
     * 
     * @return: java.lang.String 移动电话
     */

    @Column(name = "MOBILE", nullable = true, length = 50)
    public java.lang.String getMobile() {
        return this.mobile;
    }

    /**
     *方法: 设置java.lang.String
     * 
     * @param: java.lang.String 移动电话
     */
    public void setMobile(java.lang.String mobile) {
        this.mobile = mobile;
    }

    /**
     *方法: 取得java.lang.String
     * 
     * @return: java.lang.String 电子邮件
     */

    @Column(name = "EMAIL", nullable = true, length = 250)
    public java.lang.String getEmail() {
        return this.email;
    }

    /**
     *方法: 设置java.lang.String
     * 
     * @param: java.lang.String 电子邮件
     */
    public void setEmail(java.lang.String email) {
        this.email = email;
    }

    /**
     *方法: 取得java.lang.String
     * 
     * @return: java.lang.String 用户类型
     */

    @Column(name = "USERTYPE", nullable = false, length = 10)
    public java.lang.String getUsertype() {
        return this.usertype;
    }

    /**
     *方法: 设置java.lang.String
     * 
     * @param: java.lang.String 用户类型
     */
    public void setUsertype(java.lang.String usertype) {
        this.usertype = usertype;
    }

    /**
     *方法: 取得java.lang.String
     * 
     * @return: java.lang.String 是否有效
     */

    @Column(name = "ISVALID", nullable = false, length = 1)
    public java.lang.String getIsvalid() {
        return this.isvalid;
    }

    /**
     *方法: 设置java.lang.String
     * 
     * @param: java.lang.String 是否有效
     */
    public void setIsvalid(java.lang.String isvalid) {
        this.isvalid = isvalid;
    }

    /**
     *方法: 取得java.lang.String
     * 
     * @return: java.lang.String 买卖类型
     */

    @Column(name = "MAIMLX", nullable = true, length = 10)
    public java.lang.String getMaimlx() {
        return this.maimlx;
    }

    /**
     *方法: 设置java.lang.String
     * 
     * @param: java.lang.String 买卖类型
     */
    public void setMaimlx(java.lang.String maimlx) {
        this.maimlx = maimlx;
    }

    /**
     *方法: 取得java.lang.Integer
     * 
     * @return: java.lang.Integer 录入人
     */

    @Column(name = "OPERATOR", nullable = true, length = 19)
    public java.lang.Integer getOperator() {
        return this.operator;
    }

    /**
     *方法: 设置java.lang.Integer
     * 
     * @param: java.lang.Integer 录入人
     */
    public void setOperator(java.lang.Integer operator) {
        this.operator = operator;
    }

    /**
     *方法: 取得java.util.Date
     * 
     * @return: java.util.Date 录入时间
     */

    @Column(name = "OPERATIONTIME", nullable = false)
    public java.util.Date getOperationtime() {
        return this.operationtime;
    }

    /**
     *方法: 设置java.util.Date
     * 
     * @param: java.util.Date 录入时间
     */
    public void setOperationtime(java.util.Date operationtime) {
        this.operationtime = operationtime;
    }

    /**
     *方法: 取得java.util.Date
     * 
     * @return: java.util.Date lastlogin
     */

    @Column(name = "LASTLOGIN", nullable = true)
    public java.util.Date getLastlogin() {
        return this.lastlogin;
    }

    /**
     *方法: 设置java.util.Date
     * 
     * @param: java.util.Date lastlogin
     */
    public void setLastlogin(java.util.Date lastlogin) {
        this.lastlogin = lastlogin;
    }

    /**
     *方法: 取得java.lang.String
     * 
     * @return: java.lang.String iplimit
     */

    @Column(name = "IPLIMIT", nullable = true, length = 50)
    public java.lang.String getIplimit() {
        return this.iplimit;
    }

    /**
     *方法: 设置java.lang.String
     * 
     * @param: java.lang.String iplimit
     */
    public void setIplimit(java.lang.String iplimit) {
        this.iplimit = iplimit;
    }

    /**
     *方法: 取得java.lang.String
     * 
     * @return: java.lang.String 用户状态
     */

    @Column(name = "USERVERIFYSTATUS", nullable = false, length = 10)
    public java.lang.String getUserverifystatus() {
        return this.userverifystatus;
    }

    /**
     *方法: 设置java.lang.String
     * 
     * @param: java.lang.String 用户状态
     */
    public void setUserverifystatus(java.lang.String userverifystatus) {
        this.userverifystatus = userverifystatus;
    }

    /**
     *方法: 取得java.lang.String
     * 
     * @return: java.lang.String 注册来源
     */

    @Column(name = "REGSOURCE", nullable = false, length = 10)
    public java.lang.String getRegsource() {
        return this.regsource;
    }

    /**
     *方法: 设置java.lang.String
     * 
     * @param: java.lang.String 注册来源
     */
    public void setRegsource(java.lang.String regsource) {
        this.regsource = regsource;
    }

    /**
     *方法: 取得java.lang.String
     * 
     * @return: java.lang.String userpicurl
     */

    @Column(name = "USERPICURL", nullable = true, length = 200)
    public java.lang.String getUserpicurl() {
        return this.userpicurl;
    }

    /**
     *方法: 设置java.lang.String
     * 
     * @param: java.lang.String userpicurl
     */
    public void setUserpicurl(java.lang.String userpicurl) {
        this.userpicurl = userpicurl;
    }

    public java.lang.Integer getWorktypeid() {
        return worktypeid;
    }

    public void setWorktypeid(java.lang.Integer worktypeid) {
        this.worktypeid = worktypeid;
    }


    @Override
    public String toString() {
        return "SysUserEntity{" +
                "id=" + id +
                ", userid=" + userid +
                ", sysid=" + sysid +
                ", loginname='" + loginname + '\'' +
                ", password='" + password + '\'' +
                ", username='" + username + '\'' +
                ", sex='" + sex + '\'' +
                ", roleid='" + roleid + '\'' +
                ", orgid=" + orgid +
                ", certno='" + certno + '\'' +
                ", mobile='" + mobile + '\'' +
                ", email='" + email + '\'' +
                ", usertype='" + usertype + '\'' +
                ", isvalid='" + isvalid + '\'' +
                ", maimlx='" + maimlx + '\'' +
                ", operator=" + operator +
                ", operationtime=" + operationtime +
                ", lastlogin=" + lastlogin +
                ", iplimit='" + iplimit + '\'' +
                ", userverifystatus='" + userverifystatus + '\'' +
                ", regsource='" + regsource + '\'' +
                ", userpicurl='" + userpicurl + '\'' +
                ", worktypeid=" + worktypeid +
                '}';
    }
}
